Overview

Brought to you by YData

Dataset statistics

Number of variables	33
Number of observations	141250
Missing cells	705426
Missing cells (%)	15.1%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	203.3 MiB
Average record size in memory	1.5 KiB

Variable types

Text	6
Categorical	14
Numeric	6
Unsupported	1
Boolean	1
DateTime	5

Alerts

`Card Expiration Date` has constant value "12/28"	Constant
`Bank Name` has constant value "Bank of Example"	Constant
`Bank Account Type` has constant value "Checking"	Constant
`AVS Result Code` has constant value "True"	Constant
`CVV/CVC Result Code` has constant value "M"	Constant
`Fraud Action` has constant value "allow"	Constant
`Card Brand` is highly overall correlated with `Merchant Processor Type` and 2 other fields	High correlation
`Card Last 4 Digits` is highly overall correlated with `Payment Gateway Type` and 1 other fields	High correlation
`Gateway Net Settled Amount` is highly overall correlated with `Net Amount to Merchant` and 3 other fields	High correlation
`Merchant Account ID` is highly overall correlated with `Merchant Processor Type` and 3 other fields	High correlation
`Merchant Processor Type` is highly overall correlated with `Card Brand` and 4 other fields	High correlation
`Net Amount to Merchant` is highly overall correlated with `Gateway Net Settled Amount` and 3 other fields	High correlation
`Payment Gateway Type` is highly overall correlated with `Card Brand` and 5 other fields	High correlation
`Payment Method Type` is highly overall correlated with `Card Brand` and 5 other fields	High correlation
`Processor Fees` is highly overall correlated with `Merchant Processor Type` and 2 other fields	High correlation
`Processor Response Message` is highly overall correlated with `Gateway Net Settled Amount` and 4 other fields	High correlation
`Transaction Amount` is highly overall correlated with `Gateway Net Settled Amount` and 3 other fields	High correlation
`Transaction Currency` is highly overall correlated with `Merchant Account ID`	High correlation
`Transaction Status` is highly overall correlated with `Processor Response Message` and 1 other fields	High correlation
`Transaction Type` is highly overall correlated with `Gateway Net Settled Amount` and 4 other fields	High correlation
`Transaction Type` is highly imbalanced (68.6%)	Imbalance
`Transaction Status` is highly imbalanced (82.3%)	Imbalance
`Processor Response Message` is highly imbalanced (68.6%)	Imbalance
`Card Brand` has 93954 (66.5%) missing values	Missing
`Card Last 4 Digits` has 93954 (66.5%) missing values	Missing
`Bank Name` has 94406 (66.8%) missing values	Missing
`Bank Account Type` has 94406 (66.8%) missing values	Missing
`Payment Method Token` has 46844 (33.2%) missing values	Missing
`AVS Result Code` has 93954 (66.5%) missing values	Missing
`CVV/CVC Result Code` has 93954 (66.5%) missing values	Missing
`Acquirer Reference Number (ARN)` has 93954 (66.5%) missing values	Missing
`Merchant Order ID` has unique values	Unique
`Processor Response Code` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`Processor Fees` has 93954 (66.5%) zeros	Zeros

Reproduction

Analysis started	2025-07-06 23:53:35.536307
Analysis finished	2025-07-06 23:53:43.121504
Duration	7.59 seconds
Software version	ydata-profiling vv4.16.1
Download configuration	config.json

Processor Transaction ID
Text

Distinct	141176
Distinct (%)	99.9%
Missing	0
Missing (%)	0.0%
Memory size	8.9 MiB

Length

Max length	17
Median length	17
Mean length	17
Min length	17

Characters and Unicode

Total characters	2401250
Distinct characters	17
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	141102 ?
Unique (%)	99.9%

Sample

1st row	PROC-TRX-96148747
2nd row	PROC-TRX-53756634
3rd row	PROC-TRX-96643401
4th row	PROC-TRX-48503361
5th row	PROC-TRX-87613870

Value	Count	Frequency (%)
proc-trx-62682136	2	< 0.1%
proc-trx-20751798	2	< 0.1%
proc-trx-79438389	2	< 0.1%
proc-trx-25755157	2	< 0.1%
proc-trx-59325275	2	< 0.1%
proc-trx-11723443	2	< 0.1%
proc-trx-64419314	2	< 0.1%
proc-trx-46097790	2	< 0.1%
proc-trx-34038773	2	< 0.1%
proc-trx-31233803	2	< 0.1%
Other values (141166)	141230	> 99.9%

Most occurring characters

Value	Count	Frequency (%)
-	282500	11.8%
R	282500	11.8%
P	141250	5.9%
O	141250	5.9%
C	141250	5.9%
T	141250	5.9%
X	141250	5.9%
4	115131	4.8%
8	114808	4.8%
2	114778	4.8%
Other values (7)	785283	32.7%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	2401250	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
-	282500	11.8%
R	282500	11.8%
P	141250	5.9%
O	141250	5.9%
C	141250	5.9%
T	141250	5.9%
X	141250	5.9%
4	115131	4.8%
8	114808	4.8%
2	114778	4.8%
Other values (7)	785283	32.7%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	2401250	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
-	282500	11.8%
R	282500	11.8%
P	141250	5.9%
O	141250	5.9%
C	141250	5.9%
T	141250	5.9%
X	141250	5.9%
4	115131	4.8%
8	114808	4.8%
2	114778	4.8%
Other values (7)	785283	32.7%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	2401250	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
-	282500	11.8%
R	282500	11.8%
P	141250	5.9%
O	141250	5.9%
C	141250	5.9%
T	141250	5.9%
X	141250	5.9%
4	115131	4.8%
8	114808	4.8%
2	114778	4.8%
Other values (7)	785283	32.7%

Merchant Account ID
Categorical

High correlation

Distinct	15
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	9.2 MiB

MERCH_CYBERSOURCE_USD	28475
MERCH_GOCARDLESS_USD	28156
MERCH_PAYPAL_USD	28153
MERCH_CYBERSOURCE_EUR	7097
MERCH_PAYPAL_EUR	6988
Other values (10)	42381

Length

Max length	21
Median length	20
Mean length	19.00075
Min length	16

Characters and Unicode

Total characters	2683856
Distinct characters	16
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	MERCH_PAYPAL_USD
2nd row	MERCH_GOCARDLESS_USD
3rd row	MERCH_GOCARDLESS_USD
4th row	MERCH_CYBERSOURCE_GBP
5th row	MERCH_PAYPAL_USD

Common Values

Value	Count	Frequency (%)
MERCH_CYBERSOURCE_USD	28475	20.2%
MERCH_GOCARDLESS_USD	28156	19.9%
MERCH_PAYPAL_USD	28153	19.9%
MERCH_CYBERSOURCE_EUR	7097	5.0%
MERCH_PAYPAL_EUR	6988	4.9%
MERCH_GOCARDLESS_EUR	6917	4.9%
MERCH_PAYPAL_GBP	4764	3.4%
MERCH_GOCARDLESS_GBP	4711	3.3%
MERCH_CYBERSOURCE_GBP	4625	3.3%
MERCH_PAYPAL_AUD	3841	2.7%
Other values (5)	17523	12.4%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
merch_cybersource_usd	28475	20.2%
merch_gocardless_usd	28156	19.9%
merch_paypal_usd	28153	19.9%
merch_cybersource_eur	7097	5.0%
merch_paypal_eur	6988	4.9%
merch_gocardless_eur	6917	4.9%
merch_paypal_gbp	4764	3.4%
merch_gocardless_gbp	4711	3.3%
merch_cybersource_gbp	4625	3.3%
merch_paypal_aud	3841	2.7%
Other values (5)	17523	12.4%

Most occurring characters

Value	Count	Frequency (%)
E	303688	11.3%
R	303688	11.3%
C	292634	10.9%
_	282500	10.5%
S	225768	8.4%
U	164498	6.1%
A	162428	6.1%
D	152992	5.7%
M	141250	5.3%
H	141250	5.3%
Other values (6)	513160	19.1%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	2683856	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
E	303688	11.3%
R	303688	11.3%
C	292634	10.9%
_	282500	10.5%
S	225768	8.4%
U	164498	6.1%
A	162428	6.1%
D	152992	5.7%
M	141250	5.3%
H	141250	5.3%
Other values (6)	513160	19.1%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	2683856	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
E	303688	11.3%
R	303688	11.3%
C	292634	10.9%
_	282500	10.5%
S	225768	8.4%
U	164498	6.1%
A	162428	6.1%
D	152992	5.7%
M	141250	5.3%
H	141250	5.3%
Other values (6)	513160	19.1%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	2683856	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
E	303688	11.3%
R	303688	11.3%
C	292634	10.9%
_	282500	10.5%
S	225768	8.4%
U	164498	6.1%
A	162428	6.1%
D	152992	5.7%
M	141250	5.3%
H	141250	5.3%
Other values (6)	513160	19.1%

Merchant Processor Type
Categorical

High correlation

Distinct	4
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	7.7 MiB

PayPal	47110
GoCardless	46844
ClientLine	31657
Amex	15639

Length

Max length	10
Median length	10
Mean length	8.0016
Min length	4

Characters and Unicode

Total characters	1130226
Distinct characters	18
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	PayPal
2nd row	GoCardless
3rd row	GoCardless
4th row	ClientLine
5th row	PayPal

Common Values

Value	Count	Frequency (%)
PayPal	47110	33.4%
GoCardless	46844	33.2%
ClientLine	31657	22.4%
Amex	15639	11.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
paypal	47110	33.4%
gocardless	46844	33.2%
clientline	31657	22.4%
amex	15639	11.1%

Most occurring characters

Value	Count	Frequency (%)
a	141064	12.5%
e	125797	11.1%
l	125611	11.1%
P	94220	8.3%
s	93688	8.3%
C	78501	6.9%
i	63314	5.6%
n	63314	5.6%
y	47110	4.2%
G	46844	4.1%
Other values (8)	250763	22.2%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	1130226	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
a	141064	12.5%
e	125797	11.1%
l	125611	11.1%
P	94220	8.3%
s	93688	8.3%
C	78501	6.9%
i	63314	5.6%
n	63314	5.6%
y	47110	4.2%
G	46844	4.1%
Other values (8)	250763	22.2%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	1130226	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
a	141064	12.5%
e	125797	11.1%
l	125611	11.1%
P	94220	8.3%
s	93688	8.3%
C	78501	6.9%
i	63314	5.6%
n	63314	5.6%
y	47110	4.2%
G	46844	4.1%
Other values (8)	250763	22.2%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	1130226	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
a	141064	12.5%
e	125797	11.1%
l	125611	11.1%
P	94220	8.3%
s	93688	8.3%
C	78501	6.9%
i	63314	5.6%
n	63314	5.6%
y	47110	4.2%
G	46844	4.1%
Other values (8)	250763	22.2%

Transaction Type
Categorical

High correlation Imbalance

Distinct	4
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	7.6 MiB

payment	125000
refund	12500
chargeback	2500
chargeback_reversal	1250

Length

Max length	19
Median length	7
Mean length	7.0707965
Min length	6

Characters and Unicode

Total characters	998750
Distinct characters	20
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	payment
2nd row	payment
3rd row	payment
4th row	payment
5th row	payment

Common Values

Value	Count	Frequency (%)
payment	125000	88.5%
refund	12500	8.8%
chargeback	2500	1.8%
chargeback_reversal	1250	0.9%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
payment	125000	88.5%
refund	12500	8.8%
chargeback	2500	1.8%
chargeback_reversal	1250	0.9%

Most occurring characters

Value	Count	Frequency (%)
e	143750	14.4%
n	137500	13.8%
a	133750	13.4%
p	125000	12.5%
y	125000	12.5%
m	125000	12.5%
t	125000	12.5%
r	18750	1.9%
u	12500	1.3%
d	12500	1.3%
Other values (10)	40000	4.0%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	998750	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
e	143750	14.4%
n	137500	13.8%
a	133750	13.4%
p	125000	12.5%
y	125000	12.5%
m	125000	12.5%
t	125000	12.5%
r	18750	1.9%
u	12500	1.3%
d	12500	1.3%
Other values (10)	40000	4.0%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	998750	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
e	143750	14.4%
n	137500	13.8%
a	133750	13.4%
p	125000	12.5%
y	125000	12.5%
m	125000	12.5%
t	125000	12.5%
r	18750	1.9%
u	12500	1.3%
d	12500	1.3%
Other values (10)	40000	4.0%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	998750	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
e	143750	14.4%
n	137500	13.8%
a	133750	13.4%
p	125000	12.5%
y	125000	12.5%
m	125000	12.5%
t	125000	12.5%
r	18750	1.9%
u	12500	1.3%
d	12500	1.3%
Other values (10)	40000	4.0%

Transaction Status
Categorical

High correlation Imbalance

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	7.5 MiB

settled	137500
disputed	3750

Length

Max length	8
Median length	7
Mean length	7.0265487
Min length	7

Characters and Unicode

Total characters	992500
Distinct characters	8
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	settled
2nd row	settled
3rd row	settled
4th row	settled
5th row	settled

Common Values

Value	Count	Frequency (%)
settled	137500	97.3%
disputed	3750	2.7%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
settled	137500	97.3%
disputed	3750	2.7%

Most occurring characters

Value	Count	Frequency (%)
e	278750	28.1%
t	278750	28.1%
d	145000	14.6%
s	141250	14.2%
l	137500	13.9%
i	3750	0.4%
p	3750	0.4%
u	3750	0.4%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	992500	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
e	278750	28.1%
t	278750	28.1%
d	145000	14.6%
s	141250	14.2%
l	137500	13.9%
i	3750	0.4%
p	3750	0.4%
u	3750	0.4%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	992500	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
e	278750	28.1%
t	278750	28.1%
d	145000	14.6%
s	141250	14.2%
l	137500	13.9%
i	3750	0.4%
p	3750	0.4%
u	3750	0.4%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	992500	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
e	278750	28.1%
t	278750	28.1%
d	145000	14.6%
s	141250	14.2%
l	137500	13.9%
i	3750	0.4%
p	3750	0.4%
u	3750	0.4%

Transaction Amount
Real number (ℝ)

High correlation

Distinct	122801
Distinct (%)	86.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1979.2208

Minimum	-4999.85
Maximum	4999.87
Zeros	0
Zeros (%)	0.0%
Negative	15000
Negative (%)	10.6%
Memory size	1.1 MiB

Quantile statistics

Minimum	-4999.85
5-th percentile	-2655.288
Q1	828.465
median	2221.17
Q3	3607.4425
95-th percentile	4724.491
Maximum	4999.87
Range	9999.72
Interquartile range (IQR)	2778.9775

Descriptive statistics

Standard deviation	2112.685
Coefficient of variation (CV)	1.0674327
Kurtosis	1.0466637
Mean	1979.2208
Median Absolute Deviation (MAD)	1389.74
Skewness	-1.0062879
Sum	2.7956493 × 10⁸
Variance	4463437.9
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
4756.12	5	< 0.1%
953.97	5	< 0.1%
931.3	5	< 0.1%
3543.24	5	< 0.1%
4146.9	5	< 0.1%
1020.37	5	< 0.1%
1902	5	< 0.1%
2595.9	5	< 0.1%
1121	4	< 0.1%
4540.24	4	< 0.1%
Other values (122791)	141202	> 99.9%

Value	Count	Frequency (%)
-4999.85	1	< 0.1%
-4999.06	1	< 0.1%
-4998.84	2	< 0.1%
-4998.76	1	< 0.1%
-4998.23	1	< 0.1%
-4996.55	2	< 0.1%
-4996.24	1	< 0.1%
-4996.23	2	< 0.1%
-4996.21	2	< 0.1%
-4995.93	1	< 0.1%

Value	Count	Frequency (%)
4999.87	1	< 0.1%
4999.85	2	< 0.1%
4999.66	1	< 0.1%
4999.61	1	< 0.1%
4999.54	1	< 0.1%
4999.44	1	< 0.1%
4999.28	2	< 0.1%
4999.27	1	< 0.1%
4999.26	1	< 0.1%
4999.24	1	< 0.1%

Transaction Currency
Categorical

High correlation

Distinct	5
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	7.0 MiB

USD	84784
EUR	21002
GBP	14100
AUD	11416
CAD	9948

Length

Max length	3
Median length	3
Mean length	3
Min length	3

Characters and Unicode

Total characters	423750
Distinct characters	10
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	USD
2nd row	USD
3rd row	USD
4th row	GBP
5th row	USD

Common Values

Value	Count	Frequency (%)
USD	84784	60.0%
EUR	21002	14.9%
GBP	14100	10.0%
AUD	11416	8.1%
CAD	9948	7.0%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
usd	84784	60.0%
eur	21002	14.9%
gbp	14100	10.0%
aud	11416	8.1%
cad	9948	7.0%

Most occurring characters

Value	Count	Frequency (%)
U	117202	27.7%
D	106148	25.0%
S	84784	20.0%
A	21364	5.0%
E	21002	5.0%
R	21002	5.0%
G	14100	3.3%
B	14100	3.3%
P	14100	3.3%
C	9948	2.3%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	423750	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
U	117202	27.7%
D	106148	25.0%
S	84784	20.0%
A	21364	5.0%
E	21002	5.0%
R	21002	5.0%
G	14100	3.3%
B	14100	3.3%
P	14100	3.3%
C	9948	2.3%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	423750	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
U	117202	27.7%
D	106148	25.0%
S	84784	20.0%
A	21364	5.0%
E	21002	5.0%
R	21002	5.0%
G	14100	3.3%
B	14100	3.3%
P	14100	3.3%
C	9948	2.3%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	423750	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
U	117202	27.7%
D	106148	25.0%
S	84784	20.0%
A	21364	5.0%
E	21002	5.0%
R	21002	5.0%
G	14100	3.3%
B	14100	3.3%
P	14100	3.3%
C	9948	2.3%

Processor Response Code
Unsupported

Rejected Unsupported

Missing	0
Missing (%)	0.0%
Memory size	5.2 MiB

Processor Response Message
Categorical

High correlation Imbalance

Distinct	4
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	7.8 MiB

Approved	125000
Refund Processed	12500
Chargeback Initiated	2500
Chargeback Reversed	1250

Length

Max length	20
Median length	8
Mean length	9.0176991
Min length	8

Characters and Unicode

Total characters	1273750
Distinct characters	24
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Approved
2nd row	Approved
3rd row	Approved
4th row	Approved
5th row	Approved

Common Values

Value	Count	Frequency (%)
Approved	125000	88.5%
Refund Processed	12500	8.8%
Chargeback Initiated	2500	1.8%
Chargeback Reversed	1250	0.9%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
approved	125000	79.4%
refund	12500	7.9%
processed	12500	7.9%
chargeback	3750	2.4%
initiated	2500	1.6%
reversed	1250	0.8%

Most occurring characters

Value	Count	Frequency (%)
p	250000	19.6%
e	172500	13.5%
d	153750	12.1%
r	142500	11.2%
o	137500	10.8%
v	126250	9.9%
A	125000	9.8%
s	26250	2.1%
c	16250	1.3%
	16250	1.3%
Other values (14)	107500	8.4%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	1273750	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
p	250000	19.6%
e	172500	13.5%
d	153750	12.1%
r	142500	11.2%
o	137500	10.8%
v	126250	9.9%
A	125000	9.8%
s	26250	2.1%
c	16250	1.3%
	16250	1.3%
Other values (14)	107500	8.4%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	1273750	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
p	250000	19.6%
e	172500	13.5%
d	153750	12.1%
r	142500	11.2%
o	137500	10.8%
v	126250	9.9%
A	125000	9.8%
s	26250	2.1%
c	16250	1.3%
	16250	1.3%
Other values (14)	107500	8.4%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	1273750	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
p	250000	19.6%
e	172500	13.5%
d	153750	12.1%
r	142500	11.2%
o	137500	10.8%
v	126250	9.9%
A	125000	9.8%
s	26250	2.1%
c	16250	1.3%
	16250	1.3%
Other values (14)	107500	8.4%

Payment Method Type
Categorical

High correlation

Distinct	3
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	7.5 MiB

Credit Card	47296
PayPal	47110
ACH	46844

Length

Max length	11
Median length	6
Mean length	6.6792779
Min length	3

Characters and Unicode

Total characters	943448
Distinct characters	13
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	PayPal
2nd row	ACH
3rd row	ACH
4th row	Credit Card
5th row	PayPal

Common Values

Value	Count	Frequency (%)
Credit Card	47296	33.5%
PayPal	47110	33.4%
ACH	46844	33.2%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
credit	47296	25.1%
card	47296	25.1%
paypal	47110	25.0%
ach	46844	24.8%

Most occurring characters

Value	Count	Frequency (%)
a	141516	15.0%
C	141436	15.0%
r	94592	10.0%
d	94592	10.0%
P	94220	10.0%
e	47296	5.0%
i	47296	5.0%
t	47296	5.0%
	47296	5.0%
y	47110	5.0%
Other values (3)	140798	14.9%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	943448	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
a	141516	15.0%
C	141436	15.0%
r	94592	10.0%
d	94592	10.0%
P	94220	10.0%
e	47296	5.0%
i	47296	5.0%
t	47296	5.0%
	47296	5.0%
y	47110	5.0%
Other values (3)	140798	14.9%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	943448	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
a	141516	15.0%
C	141436	15.0%
r	94592	10.0%
d	94592	10.0%
P	94220	10.0%
e	47296	5.0%
i	47296	5.0%
t	47296	5.0%
	47296	5.0%
y	47110	5.0%
Other values (3)	140798	14.9%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	943448	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
a	141516	15.0%
C	141436	15.0%
r	94592	10.0%
d	94592	10.0%
P	94220	10.0%
e	47296	5.0%
i	47296	5.0%
t	47296	5.0%
	47296	5.0%
y	47110	5.0%
Other values (3)	140798	14.9%

Card Brand
Categorical

High correlation Missing

Distinct	3
Distinct (%)	< 0.1%
Missing	93954
Missing (%)	66.5%
Memory size	7.5 MiB

Mastercard	15960
Visa	15697
Amex	15639

Length

Max length	10
Median length	4
Mean length	6.0246955
Min length	4

Characters and Unicode

Total characters	284944
Distinct characters	13
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Visa
2nd row	Mastercard
3rd row	Amex
4th row	Mastercard
5th row	Visa

Common Values

Value	Count	Frequency (%)
Mastercard	15960	11.3%
Visa	15697	11.1%
Amex	15639	11.1%
(Missing)	93954	66.5%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
mastercard	15960	33.7%
visa	15697	33.2%
amex	15639	33.1%

Most occurring characters

Value	Count	Frequency (%)
a	47617	16.7%
r	31920	11.2%
s	31657	11.1%
e	31599	11.1%
M	15960	5.6%
t	15960	5.6%
c	15960	5.6%
d	15960	5.6%
V	15697	5.5%
i	15697	5.5%
Other values (3)	46917	16.5%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	284944	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
a	47617	16.7%
r	31920	11.2%
s	31657	11.1%
e	31599	11.1%
M	15960	5.6%
t	15960	5.6%
c	15960	5.6%
d	15960	5.6%
V	15697	5.5%
i	15697	5.5%
Other values (3)	46917	16.5%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	284944	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
a	47617	16.7%
r	31920	11.2%
s	31657	11.1%
e	31599	11.1%
M	15960	5.6%
t	15960	5.6%
c	15960	5.6%
d	15960	5.6%
V	15697	5.5%
i	15697	5.5%
Other values (3)	46917	16.5%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	284944	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
a	47617	16.7%
r	31920	11.2%
s	31657	11.1%
e	31599	11.1%
M	15960	5.6%
t	15960	5.6%
c	15960	5.6%
d	15960	5.6%
V	15697	5.5%
i	15697	5.5%
Other values (3)	46917	16.5%

Card Last 4 Digits
Real number (ℝ)

High correlation Missing

Distinct	8963
Distinct (%)	19.0%
Missing	93954
Missing (%)	66.5%
Infinite	0
Infinite (%)	0.0%
Mean	5511.9391

Minimum	1000
Maximum	9999
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	1.1 MiB

Quantile statistics

Minimum	1000
5-th percentile	1459.75
Q1	3267
median	5540.5
Q3	7743.25
95-th percentile	9541
Maximum	9999
Range	8999
Interquartile range (IQR)	4476.25

Descriptive statistics

Standard deviation	2588.5975
Coefficient of variation (CV)	0.46963463
Kurtosis	-1.1929835
Mean	5511.9391
Median Absolute Deviation (MAD)	2238.5
Skewness	-0.0087537714
Sum	2.6069267 × 10⁸
Variance	6700836.9
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
5062	16	< 0.1%
2609	15	< 0.1%
9615	15	< 0.1%
9126	15	< 0.1%
9930	15	< 0.1%
7952	14	< 0.1%
6197	14	< 0.1%
4571	14	< 0.1%
3207	14	< 0.1%
3872	14	< 0.1%
Other values (8953)	47150	33.4%
(Missing)	93954	66.5%

Value	Count	Frequency (%)
1000	3	< 0.1%
1001	4	< 0.1%
1002	3	< 0.1%
1003	4	< 0.1%
1004	3	< 0.1%
1005	5	< 0.1%
1006	7	< 0.1%
1007	5	< 0.1%
1008	3	< 0.1%
1009	6	< 0.1%

Value	Count	Frequency (%)
9999	7	< 0.1%
9998	8	< 0.1%
9997	7	< 0.1%
9996	5	< 0.1%
9995	5	< 0.1%
9994	6	< 0.1%
9993	5	< 0.1%
9992	7	< 0.1%
9991	8	< 0.1%
9990	7	< 0.1%

Card Expiration Date
Categorical

Constant

Distinct	1
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	7.3 MiB

12/28	141250

Length

Max length	5
Median length	5
Mean length	5
Min length	5

Characters and Unicode

Total characters	706250
Distinct characters	4
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	12/28
2nd row	12/28
3rd row	12/28
4th row	12/28
5th row	12/28

Common Values

Value	Count	Frequency (%)
12/28	141250	100.0%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
12/28	141250	100.0%

Most occurring characters

Value	Count	Frequency (%)
2	282500	40.0%
1	141250	20.0%
/	141250	20.0%
8	141250	20.0%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	706250	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
2	282500	40.0%
1	141250	20.0%
/	141250	20.0%
8	141250	20.0%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	706250	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
2	282500	40.0%
1	141250	20.0%
/	141250	20.0%
8	141250	20.0%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	706250	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
2	282500	40.0%
1	141250	20.0%
/	141250	20.0%
8	141250	20.0%

Bank Name
Categorical

Constant Missing

Distinct	1
Distinct (%)	< 0.1%
Missing	94406
Missing (%)	66.8%
Memory size	7.9 MiB

Bank of Example	46844

Length

Max length	15
Median length	15
Mean length	15
Min length	15

Characters and Unicode

Total characters	702660
Distinct characters	13
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Bank of Example
2nd row	Bank of Example
3rd row	Bank of Example
4th row	Bank of Example
5th row	Bank of Example

Common Values

Value	Count	Frequency (%)
Bank of Example	46844	33.2%
(Missing)	94406	66.8%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
bank	46844	33.3%
of	46844	33.3%
example	46844	33.3%

Most occurring characters

Value	Count	Frequency (%)
a	93688	13.3%
	93688	13.3%
B	46844	6.7%
n	46844	6.7%
k	46844	6.7%
o	46844	6.7%
f	46844	6.7%
E	46844	6.7%
x	46844	6.7%
m	46844	6.7%
Other values (3)	140532	20.0%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	702660	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
a	93688	13.3%
	93688	13.3%
B	46844	6.7%
n	46844	6.7%
k	46844	6.7%
o	46844	6.7%
f	46844	6.7%
E	46844	6.7%
x	46844	6.7%
m	46844	6.7%
Other values (3)	140532	20.0%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	702660	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
a	93688	13.3%
	93688	13.3%
B	46844	6.7%
n	46844	6.7%
k	46844	6.7%
o	46844	6.7%
f	46844	6.7%
E	46844	6.7%
x	46844	6.7%
m	46844	6.7%
Other values (3)	140532	20.0%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	702660	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
a	93688	13.3%
	93688	13.3%
B	46844	6.7%
n	46844	6.7%
k	46844	6.7%
o	46844	6.7%
f	46844	6.7%
E	46844	6.7%
x	46844	6.7%
m	46844	6.7%
Other values (3)	140532	20.0%

Bank Account Type
Categorical

Constant Missing

Distinct	1
Distinct (%)	< 0.1%
Missing	94406
Missing (%)	66.8%
Memory size	7.6 MiB

Checking	46844

Length

Max length	8
Median length	8
Mean length	8
Min length	8

Characters and Unicode

Total characters	374752
Distinct characters	8
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Checking
2nd row	Checking
3rd row	Checking
4th row	Checking
5th row	Checking

Common Values

Value	Count	Frequency (%)
Checking	46844	33.2%
(Missing)	94406	66.8%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
checking	46844	100.0%

Most occurring characters

Value	Count	Frequency (%)
C	46844	12.5%
h	46844	12.5%
e	46844	12.5%
c	46844	12.5%
k	46844	12.5%
i	46844	12.5%
n	46844	12.5%
g	46844	12.5%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	374752	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
C	46844	12.5%
h	46844	12.5%
e	46844	12.5%
c	46844	12.5%
k	46844	12.5%
i	46844	12.5%
n	46844	12.5%
g	46844	12.5%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	374752	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
C	46844	12.5%
h	46844	12.5%
e	46844	12.5%
c	46844	12.5%
k	46844	12.5%
i	46844	12.5%
n	46844	12.5%
g	46844	12.5%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	374752	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
C	46844	12.5%
h	46844	12.5%
e	46844	12.5%
c	46844	12.5%
k	46844	12.5%
i	46844	12.5%
n	46844	12.5%
g	46844	12.5%

Payment Method Token
Text

Missing

Distinct	89597
Distinct (%)	94.9%
Missing	46844
Missing (%)	33.2%
Memory size	6.7 MiB

Length

Max length	10
Median length	10
Mean length	10
Min length	10

Characters and Unicode

Total characters	944060
Distinct characters	14
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	84954 ?
Unique (%)	90.0%

Sample

1st row	TOK_850912
2nd row	TOK_268155
3rd row	TOK_866077
4th row	TOK_244127
5th row	TOK_513827

Value	Count	Frequency (%)
tok_962548	4	< 0.1%
tok_646979	4	< 0.1%
tok_257937	4	< 0.1%
tok_974943	4	< 0.1%
tok_820511	4	< 0.1%
tok_973529	4	< 0.1%
tok_769620	4	< 0.1%
tok_426828	3	< 0.1%
tok_848212	3	< 0.1%
tok_265257	3	< 0.1%
Other values (89587)	94369	> 99.9%

Most occurring characters

Value	Count	Frequency (%)
T	94406	10.0%
O	94406	10.0%
K	94406	10.0%
_	94406	10.0%
4	58303	6.2%
2	57878	6.1%
7	57825	6.1%
1	57804	6.1%
9	57751	6.1%
8	57626	6.1%
Other values (4)	219249	23.2%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	944060	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
T	94406	10.0%
O	94406	10.0%
K	94406	10.0%
_	94406	10.0%
4	58303	6.2%
2	57878	6.1%
7	57825	6.1%
1	57804	6.1%
9	57751	6.1%
8	57626	6.1%
Other values (4)	219249	23.2%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	944060	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
T	94406	10.0%
O	94406	10.0%
K	94406	10.0%
_	94406	10.0%
4	58303	6.2%
2	57878	6.1%
7	57825	6.1%
1	57804	6.1%
9	57751	6.1%
8	57626	6.1%
Other values (4)	219249	23.2%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	944060	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
T	94406	10.0%
O	94406	10.0%
K	94406	10.0%
_	94406	10.0%
4	58303	6.2%
2	57878	6.1%
7	57825	6.1%
1	57804	6.1%
9	57751	6.1%
8	57626	6.1%
Other values (4)	219249	23.2%

Merchant Order ID
Text

Unique

Distinct	141250
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Memory size	8.1 MiB

Length

Max length	11
Median length	11
Mean length	11
Min length	11

Characters and Unicode

Total characters	1553750
Distinct characters	21
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	141250 ?
Unique (%)	100.0%

Sample

1st row	PAY-0000000
2nd row	PAY-0000001
3rd row	PAY-0000002
4th row	PAY-0000003
5th row	PAY-0000004

Value	Count	Frequency (%)
pay-0000000	1	< 0.1%
pay-0000011	1	< 0.1%
pay-0000017	1	< 0.1%
pay-0000016	1	< 0.1%
pay-0000015	1	< 0.1%
pay-0000014	1	< 0.1%
pay-0000013	1	< 0.1%
pay-0000012	1	< 0.1%
pay-0000010	1	< 0.1%
pay-0000070	1	< 0.1%
Other values (141240)	141240	> 99.9%

Most occurring characters

Value	Count	Frequency (%)
0	334091	21.5%
-	141250	9.1%
P	125000	8.0%
Y	125000	8.0%
A	125000	8.0%
1	107672	6.9%
2	73838	4.8%
4	68511	4.4%
3	68239	4.4%
5	67331	4.3%
Other values (11)	317818	20.5%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	1553750	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
0	334091	21.5%
-	141250	9.1%
P	125000	8.0%
Y	125000	8.0%
A	125000	8.0%
1	107672	6.9%
2	73838	4.8%
4	68511	4.4%
3	68239	4.4%
5	67331	4.3%
Other values (11)	317818	20.5%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	1553750	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
0	334091	21.5%
-	141250	9.1%
P	125000	8.0%
Y	125000	8.0%
A	125000	8.0%
1	107672	6.9%
2	73838	4.8%
4	68511	4.4%
3	68239	4.4%
5	67331	4.3%
Other values (11)	317818	20.5%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	1553750	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
0	334091	21.5%
-	141250	9.1%
P	125000	8.0%
Y	125000	8.0%
A	125000	8.0%
1	107672	6.9%
2	73838	4.8%
4	68511	4.4%
3	68239	4.4%
5	67331	4.3%
Other values (11)	317818	20.5%

Customer ID
Text

Distinct	9000
Distinct (%)	6.4%
Missing	0
Missing (%)	0.0%
Memory size	8.5 MiB

Length

Max length	14
Median length	14
Mean length	14
Min length	14

Characters and Unicode

Total characters	1977500
Distinct characters	18
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	CUST-PROC-2479
2nd row	CUST-PROC-4051
3rd row	CUST-PROC-4566
4th row	CUST-PROC-4425
5th row	CUST-PROC-1238

Value	Count	Frequency (%)
cust-proc-1707	32	< 0.1%
cust-proc-7936	31	< 0.1%
cust-proc-9420	31	< 0.1%
cust-proc-6208	30	< 0.1%
cust-proc-4665	30	< 0.1%
cust-proc-4237	29	< 0.1%
cust-proc-7787	29	< 0.1%
cust-proc-7756	29	< 0.1%
cust-proc-3780	29	< 0.1%
cust-proc-6749	29	< 0.1%
Other values (8990)	140951	99.8%

Most occurring characters

Value	Count	Frequency (%)
C	282500	14.3%
-	282500	14.3%
U	141250	7.1%
S	141250	7.1%
T	141250	7.1%
P	141250	7.1%
R	141250	7.1%
O	141250	7.1%
4	58176	2.9%
7	58165	2.9%
Other values (8)	448659	22.7%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	1977500	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
C	282500	14.3%
-	282500	14.3%
U	141250	7.1%
S	141250	7.1%
T	141250	7.1%
P	141250	7.1%
R	141250	7.1%
O	141250	7.1%
4	58176	2.9%
7	58165	2.9%
Other values (8)	448659	22.7%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	1977500	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
C	282500	14.3%
-	282500	14.3%
U	141250	7.1%
S	141250	7.1%
T	141250	7.1%
P	141250	7.1%
R	141250	7.1%
O	141250	7.1%
4	58176	2.9%
7	58165	2.9%
Other values (8)	448659	22.7%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	1977500	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
C	282500	14.3%
-	282500	14.3%
U	141250	7.1%
S	141250	7.1%
T	141250	7.1%
P	141250	7.1%
R	141250	7.1%
O	141250	7.1%
4	58176	2.9%
7	58165	2.9%
Other values (8)	448659	22.7%

AVS Result Code
Boolean

Constant Missing

Distinct	1
Distinct (%)	< 0.1%
Missing	93954
Missing (%)	66.5%
Memory size	276.0 KiB

True	47296
(Missing)	93954

Value	Count	Frequency (%)
True	47296	33.5%
(Missing)	93954	66.5%

CVV/CVC Result Code
Categorical

Constant Missing

Distinct	1
Distinct (%)	< 0.1%
Missing	93954
Missing (%)	66.5%
Memory size	7.3 MiB

M	47296

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	47296
Distinct characters	1
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	M
2nd row	M
3rd row	M
4th row	M
5th row	M

Common Values

Value	Count	Frequency (%)
M	47296	33.5%
(Missing)	93954	66.5%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
m	47296	100.0%

Most occurring characters

Value	Count	Frequency (%)
M	47296	100.0%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	47296	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
M	47296	100.0%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	47296	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
M	47296	100.0%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	47296	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
M	47296	100.0%

Fraud Score
Real number (ℝ)

Distinct	1001
Distinct (%)	0.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	49.969022

Minimum	0
Maximum	100
Zeros	68
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	1.1 MiB

Quantile statistics

Minimum	0
5-th percentile	5
Q1	25
median	49.9
Q3	75
95-th percentile	95
Maximum	100
Range	100
Interquartile range (IQR)	50

Descriptive statistics

Standard deviation	28.884486
Coefficient of variation (CV)	0.57804785
Kurtosis	-1.2018133
Mean	49.969022
Median Absolute Deviation (MAD)	25
Skewness	0.0038236209
Sum	7058124.4
Variance	834.31353
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
38.3	181	0.1%
64.2	178	0.1%
31.9	178	0.1%
38.6	176	0.1%
70.8	175	0.1%
0.1	175	0.1%
80.8	174	0.1%
22.8	173	0.1%
89.3	173	0.1%
63.9	170	0.1%
Other values (991)	139497	98.8%

Value	Count	Frequency (%)
0	68	< 0.1%
0.1	175	0.1%
0.2	143	0.1%
0.3	152	0.1%
0.4	131	0.1%
0.5	147	0.1%
0.6	131	0.1%
0.7	159	0.1%
0.8	150	0.1%
0.9	143	0.1%

Value	Count	Frequency (%)
100	77	0.1%
99.9	126	0.1%
99.8	138	0.1%
99.7	144	0.1%
99.6	156	0.1%
99.5	127	0.1%
99.4	155	0.1%
99.3	126	0.1%
99.2	135	0.1%
99.1	139	0.1%

Fraud Action
Categorical

Constant

Distinct	1
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	7.3 MiB

allow	141250

Length

Max length	5
Median length	5
Mean length	5
Min length	5

Characters and Unicode

Total characters	706250
Distinct characters	4
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	allow
2nd row	allow
3rd row	allow
4th row	allow
5th row	allow

Common Values

Value	Count	Frequency (%)
allow	141250	100.0%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
allow	141250	100.0%

Most occurring characters

Value	Count	Frequency (%)
l	282500	40.0%
a	141250	20.0%
o	141250	20.0%
w	141250	20.0%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	706250	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
l	282500	40.0%
a	141250	20.0%
o	141250	20.0%
w	141250	20.0%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	706250	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
l	282500	40.0%
a	141250	20.0%
o	141250	20.0%
w	141250	20.0%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	706250	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
l	282500	40.0%
a	141250	20.0%
o	141250	20.0%
w	141250	20.0%

Gateway Net Settled Amount
Real number (ℝ)

High correlation

Distinct	124790
Distinct (%)	88.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1962.4242

Minimum	-5046.2
Maximum	4987.37
Zeros	0
Zeros (%)	0.0%
Negative	15000
Negative (%)	10.6%
Memory size	1.1 MiB

Quantile statistics

Minimum	-5046.2
5-th percentile	-2672.5785
Q1	822.68
median	2206.12
Q3	3583.4875
95-th percentile	4692.4065
Maximum	4987.37
Range	10033.57
Interquartile range (IQR)	2760.8075

Descriptive statistics

Standard deviation	2107.6026
Coefficient of variation (CV)	1.0739791
Kurtosis	1.0941128
Mean	1962.4242
Median Absolute Deviation (MAD)	1380.015
Skewness	-1.0220654
Sum	2.7719242 × 10⁸
Variance	4441988.9
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
3385.57	5	< 0.1%
3300.21	5	< 0.1%
2897.74	5	< 0.1%
4796.47	5	< 0.1%
2508.85	4	< 0.1%
740.26	4	< 0.1%
1054.78	4	< 0.1%
1727.27	4	< 0.1%
2273.48	4	< 0.1%
1768.97	4	< 0.1%
Other values (124780)	141206	> 99.9%

Value	Count	Frequency (%)
-5046.2	1	< 0.1%
-5045.89	1	< 0.1%
-5045.17	1	< 0.1%
-5044.44	1	< 0.1%
-5044.03	1	< 0.1%
-5042.96	1	< 0.1%
-5042.84	1	< 0.1%
-5042.64	1	< 0.1%
-5039.5	1	< 0.1%
-5039.08	1	< 0.1%

Value	Count	Frequency (%)
4987.37	1	< 0.1%
4987.35	1	< 0.1%
4987.11	1	< 0.1%
4987.04	1	< 0.1%
4986.94	1	< 0.1%
4986.78	2	< 0.1%
4986.68	1	< 0.1%
4986.35	1	< 0.1%
4986.34	1	< 0.1%
4986.23	1	< 0.1%

Processor Fees
Real number (ℝ)

High correlation Zeros

Distinct	7087
Distinct (%)	5.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	9.8112149

Minimum	0
Maximum	74.99
Zeros	93954
Zeros (%)	66.5%
Negative	0
Negative (%)	0.0%
Memory size	1.1 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	14.46
95-th percentile	47.98
Maximum	74.99
Range	74.99
Interquartile range (IQR)	14.46

Descriptive statistics

Standard deviation	17.32999
Coefficient of variation (CV)	1.7663449
Kurtosis	1.9714233
Mean	9.8112149
Median Absolute Deviation (MAD)	0
Skewness	1.7263428
Sum	1385834.1
Variance	300.32854
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	93954	66.5%
41.01	24	< 0.1%
38.4	24	< 0.1%
15.22	24	< 0.1%
9.17	23	< 0.1%
12.85	23	< 0.1%
9.3	23	< 0.1%
17.81	23	< 0.1%
27.07	23	< 0.1%
28.66	22	< 0.1%
Other values (7077)	47087	33.3%

Value	Count	Frequency (%)
0	93954	66.5%
0.26	5	< 0.1%
0.27	9	< 0.1%
0.28	7	< 0.1%
0.29	3	< 0.1%
0.3	10	< 0.1%
0.31	2	< 0.1%
0.32	7	< 0.1%
0.33	7	< 0.1%
0.34	3	< 0.1%

Value	Count	Frequency (%)
74.99	1	< 0.1%
74.98	3	< 0.1%
74.97	2	< 0.1%
74.95	2	< 0.1%
74.94	5	< 0.1%
74.93	4	< 0.1%
74.92	1	< 0.1%
74.91	1	< 0.1%
74.9	2	< 0.1%
74.89	2	< 0.1%

Net Amount to Merchant
Real number (ℝ)

High correlation

Distinct	126072
Distinct (%)	89.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1952.613

Minimum	-5121.14
Maximum	4987.37
Zeros	0
Zeros (%)	0.0%
Negative	15000
Negative (%)	10.6%
Memory size	1.1 MiB

Quantile statistics

Minimum	-5121.14
5-th percentile	-2686.679
Q1	818.9725
median	2198.58
Q3	3568.6375
95-th percentile	4673.3085
Maximum	4987.37
Range	10108.51
Interquartile range (IQR)	2749.665

Descriptive statistics

Standard deviation	2104.7798
Coefficient of variation (CV)	1.0779298
Kurtosis	1.1223452
Mean	1952.613
Median Absolute Deviation (MAD)	1375.175
Skewness	-1.0310854
Sum	2.7580658 × 10⁸
Variance	4430098
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
398.52	5	< 0.1%
3598.04	5	< 0.1%
453.83	5	< 0.1%
4242.54	4	< 0.1%
3644.56	4	< 0.1%
4329.09	4	< 0.1%
1088.79	4	< 0.1%
1003.37	4	< 0.1%
2042.33	4	< 0.1%
257.12	4	< 0.1%
Other values (126062)	141207	> 99.9%

Value	Count	Frequency (%)
-5121.14	1	< 0.1%
-5120.1	1	< 0.1%
-5114.34	1	< 0.1%
-5112.98	1	< 0.1%
-5112.86	2	< 0.1%
-5107.75	1	< 0.1%
-5097.22	1	< 0.1%
-5095.85	1	< 0.1%
-5094.91	1	< 0.1%
-5094.38	1	< 0.1%

Value	Count	Frequency (%)
4987.37	1	< 0.1%
4987.35	1	< 0.1%
4987.11	1	< 0.1%
4987.04	1	< 0.1%
4986.94	1	< 0.1%
4986.78	2	< 0.1%
4986.68	1	< 0.1%
4986.35	1	< 0.1%
4986.34	1	< 0.1%
4986.23	1	< 0.1%

Settlement Batch ID
Text

Distinct	2250
Distinct (%)	1.6%
Missing	0
Missing (%)	0.0%
Memory size	10.6 MiB

Length

Max length	38
Median length	32
Mean length	30.014386
Min length	26

Characters and Unicode

Total characters	4239532
Distinct characters	41
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	SET-20250130-PayPal-N/A-USD
2nd row	SET-20250110-GoCardless-N/A-USD
3rd row	SET-20250221-GoCardless-N/A-USD
4th row	SET-20250104-ClientLine-Visa-GBP
5th row	SET-20250316-PayPal-N/A-USD

Value	Count	Frequency (%)
set-20250102-paypal-n/a-usd	360	0.3%
set-20250202-paypal-n/a-usd	359	0.3%
set-20250120-paypal-n/a-usd	352	0.2%
set-20250314-paypal-n/a-usd	350	0.2%
set-20250313-gocardless-n/a-usd	349	0.2%
set-20250112-paypal-n/a-usd	348	0.2%
set-20250115-gocardless-n/a-usd	346	0.2%
set-20250304-paypal-n/a-usd	345	0.2%
set-20250316-paypal-n/a-usd	344	0.2%
set-20250202-gocardless-n/a-usd	344	0.2%
Other values (2240)	137753	97.5%

Most occurring characters

Value	Count	Frequency (%)
-	565000	13.3%
2	386343	9.1%
0	337359	8.0%
S	226034	5.3%
a	188681	4.5%
E	162252	3.8%
e	157396	3.7%
5	155521	3.7%
A	146596	3.5%
T	141250	3.3%
Other values (31)	1773100	41.8%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	4239532	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
-	565000	13.3%
2	386343	9.1%
0	337359	8.0%
S	226034	5.3%
a	188681	4.5%
E	162252	3.8%
e	157396	3.7%
5	155521	3.7%
A	146596	3.5%
T	141250	3.3%
Other values (31)	1773100	41.8%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	4239532	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
-	565000	13.3%
2	386343	9.1%
0	337359	8.0%
S	226034	5.3%
a	188681	4.5%
E	162252	3.8%
e	157396	3.7%
5	155521	3.7%
A	146596	3.5%
T	141250	3.3%
Other values (31)	1773100	41.8%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	4239532	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
-	565000	13.3%
2	386343	9.1%
0	337359	8.0%
S	226034	5.3%
a	188681	4.5%
E	162252	3.8%
e	157396	3.7%
5	155521	3.7%
A	146596	3.5%
T	141250	3.3%
Other values (31)	1773100	41.8%

Settlement Date
Date

Distinct	65
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	1.1 MiB

Minimum	2025-01-02 00:00:00
Maximum	2025-04-02 00:00:00
Invalid dates	0
Invalid dates (%)	0.0%

Histogram with fixed size bins (bins=50)

Acquirer Reference Number (ARN)
Text

Missing

Distinct	47296
Distinct (%)	100.0%
Missing	93954
Missing (%)	66.5%
Memory size	5.6 MiB

Length

Max length	12
Median length	12
Mean length	12
Min length	12

Characters and Unicode

Total characters	567552
Distinct characters	13
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	47296 ?
Unique (%)	100.0%

Sample

1st row	ARN618188908
2nd row	ARN591055160
3rd row	ARN184492302
4th row	ARN314680266
5th row	ARN615595718

Value	Count	Frequency (%)
arn276300877	1	< 0.1%
arn213177541	1	< 0.1%
arn669849388	1	< 0.1%
arn629677896	1	< 0.1%
arn591055160	1	< 0.1%
arn184492302	1	< 0.1%
arn314680266	1	< 0.1%
arn615595718	1	< 0.1%
arn594832966	1	< 0.1%
arn508354528	1	< 0.1%
Other values (47286)	47286	> 99.9%

Most occurring characters

Value	Count	Frequency (%)
A	47296	8.3%
R	47296	8.3%
N	47296	8.3%
2	43333	7.6%
3	43163	7.6%
6	43124	7.6%
7	43103	7.6%
9	43094	7.6%
5	43048	7.6%
8	43038	7.6%
Other values (3)	123761	21.8%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	567552	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
A	47296	8.3%
R	47296	8.3%
N	47296	8.3%
2	43333	7.6%
3	43163	7.6%
6	43124	7.6%
7	43103	7.6%
9	43094	7.6%
5	43048	7.6%
8	43038	7.6%
Other values (3)	123761	21.8%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	567552	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
A	47296	8.3%
R	47296	8.3%
N	47296	8.3%
2	43333	7.6%
3	43163	7.6%
6	43124	7.6%
7	43103	7.6%
9	43094	7.6%
5	43048	7.6%
8	43038	7.6%
Other values (3)	123761	21.8%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	567552	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
A	47296	8.3%
R	47296	8.3%
N	47296	8.3%
2	43333	7.6%
3	43163	7.6%
6	43124	7.6%
7	43103	7.6%
9	43094	7.6%
5	43048	7.6%
8	43038	7.6%
Other values (3)	123761	21.8%

Transaction Timestamp
Date

Distinct	90
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	1.1 MiB

Minimum	2025-01-01 00:00:00
Maximum	2025-03-31 00:00:00
Invalid dates	0
Invalid dates (%)	0.0%

Histogram with fixed size bins (bins=50)

Last Update Timestamp
Date

Distinct	90
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	1.1 MiB

Minimum	2025-01-01 00:00:00
Maximum	2025-03-31 00:00:00
Invalid dates	0
Invalid dates (%)	0.0%

Histogram with fixed size bins (bins=50)

Payment Gateway Date
Date

Distinct	90
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	1.1 MiB

Minimum	2025-01-01 00:00:00
Maximum	2025-03-31 00:00:00
Invalid dates	0
Invalid dates (%)	0.0%

Histogram with fixed size bins (bins=50)

Payout Date
Date

Distinct	65
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	1.1 MiB

Minimum	2025-01-02 00:00:00
Maximum	2025-04-02 00:00:00
Invalid dates	0
Invalid dates (%)	0.0%

Histogram with fixed size bins (bins=50)

Payment Gateway Type
Categorical

High correlation

Distinct	3
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	7.8 MiB

Cybersource	47296
PayPal	47110
GoCardless	46844

Length

Max length	11
Median length	10
Mean length	9.0007504
Min length	6

Characters and Unicode

Total characters	1271356
Distinct characters	14
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	PayPal
2nd row	GoCardless
3rd row	GoCardless
4th row	Cybersource
5th row	PayPal

Common Values

Value	Count	Frequency (%)
Cybersource	47296	33.5%
PayPal	47110	33.4%
GoCardless	46844	33.2%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
cybersource	47296	33.5%
paypal	47110	33.4%
gocardless	46844	33.2%

Most occurring characters

Value	Count	Frequency (%)
e	141436	11.1%
r	141436	11.1%
a	141064	11.1%
s	140984	11.1%
y	94406	7.4%
P	94220	7.4%
C	94140	7.4%
o	94140	7.4%
l	93954	7.4%
b	47296	3.7%
Other values (4)	188280	14.8%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	1271356	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
e	141436	11.1%
r	141436	11.1%
a	141064	11.1%
s	140984	11.1%
y	94406	7.4%
P	94220	7.4%
C	94140	7.4%
o	94140	7.4%
l	93954	7.4%
b	47296	3.7%
Other values (4)	188280	14.8%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	1271356	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
e	141436	11.1%
r	141436	11.1%
a	141064	11.1%
s	140984	11.1%
y	94406	7.4%
P	94220	7.4%
C	94140	7.4%
o	94140	7.4%
l	93954	7.4%
b	47296	3.7%
Other values (4)	188280	14.8%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	1271356	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
e	141436	11.1%
r	141436	11.1%
a	141064	11.1%
s	140984	11.1%
y	94406	7.4%
P	94220	7.4%
C	94140	7.4%
o	94140	7.4%
l	93954	7.4%
b	47296	3.7%
Other values (4)	188280	14.8%

Interactions

Correlations

	Card Brand	Card Last 4 Digits	Fraud Score	Gateway Net Settled Amount	Merchant Account ID	Merchant Processor Type	Net Amount to Merchant	Payment Gateway Type	Payment Method Type	Processor Fees	Processor Response Message	Transaction Amount	Transaction Currency	Transaction Status	Transaction Type
Card Brand	1.000	0.000	0.000	0.012	0.006	1.000	0.013	1.000	1.000	0.336	0.000	0.012	0.006	0.000	0.000
Card Last 4 Digits	0.000	1.000	-0.006	0.005	0.000	0.000	0.005	1.000	1.000	0.004	0.000	0.005	0.000	0.000	0.000
Fraud Score	0.000	-0.006	1.000	0.001	0.003	0.000	0.001	0.001	0.001	0.002	0.003	0.001	0.005	0.008	0.003
Gateway Net Settled Amount	0.012	0.005	0.001	1.000	0.002	0.004	1.000	0.000	0.000	0.095	0.577	1.000	0.004	0.300	0.577
Merchant Account ID	0.006	0.000	0.003	0.002	1.000	0.816	0.005	1.000	1.000	0.302	0.000	0.000	1.000	0.006	0.000
Merchant Processor Type	1.000	0.000	0.000	0.004	0.816	1.000	0.011	1.000	1.000	0.589	0.000	0.000	0.001	0.004	0.000
Net Amount to Merchant	0.013	0.005	0.001	1.000	0.005	0.011	1.000	0.012	0.012	0.086	0.575	1.000	0.004	0.300	0.575
Payment Gateway Type	1.000	1.000	0.001	0.000	1.000	1.000	0.012	1.000	1.000	0.640	0.000	0.000	0.000	0.005	0.000
Payment Method Type	1.000	1.000	0.001	0.000	1.000	1.000	0.012	1.000	1.000	0.640	0.000	0.000	0.000	0.005	0.000
Processor Fees	0.336	0.004	0.002	0.095	0.302	0.589	0.086	0.640	0.640	1.000	0.006	0.098	0.001	0.010	0.006
Processor Response Message	0.000	0.000	0.003	0.577	0.000	0.000	0.575	0.000	0.000	0.006	1.000	0.577	0.000	1.000	1.000
Transaction Amount	0.012	0.005	0.001	1.000	0.000	0.000	1.000	0.000	0.000	0.098	0.577	1.000	0.004	0.301	0.577
Transaction Currency	0.006	0.000	0.005	0.004	1.000	0.001	0.004	0.000	0.000	0.001	0.000	0.004	1.000	0.000	0.000
Transaction Status	0.000	0.000	0.008	0.300	0.006	0.004	0.300	0.005	0.005	0.010	1.000	0.301	0.000	1.000	1.000
Transaction Type	0.000	0.000	0.003	0.577	0.000	0.000	0.575	0.000	0.000	0.006	1.000	0.577	0.000	1.000	1.000

Missing values

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.

Sample

	Processor Transaction ID	Merchant Account ID	Merchant Processor Type	Transaction Type	Transaction Status	Transaction Amount	Transaction Currency	Processor Response Message	Payment Method Type	Card Brand	Card Last 4 Digits	Card Expiration Date	Bank Name	Bank Account Type	Payment Method Token	Merchant Order ID	Customer ID	AVS Result Code	CVV/CVC Result Code	Fraud Score	Fraud Action	Gateway Net Settled Amount	Processor Fees	Net Amount to Merchant	Settlement Batch ID	Settlement Date	Acquirer Reference Number (ARN)	Transaction Timestamp	Last Update Timestamp	Payment Gateway Date	Payout Date	Payment Gateway Type
0	PROC-TRX-96148747	MERCH_PAYPAL_USD	PayPal	payment	settled	2592.98	USD	Approved	PayPal	NaN	NaN	12/28	NaN	NaN	TOK_850912	PAY-0000000	CUST-PROC-2479	NaN	NaN	60.6	allow	2573.53	0.00	2573.53	SET-20250130-PayPal-N/A-USD	2025-01-31	NaN	2025-01-30	2025-01-30	2025-01-30	2025-01-31	PayPal
1	PROC-TRX-53756634	MERCH_GOCARDLESS_USD	GoCardless	payment	settled	4277.28	USD	Approved	ACH	NaN	NaN	12/28	Bank of Example	Checking	NaN	PAY-0000001	CUST-PROC-4051	NaN	NaN	0.6	allow	4266.59	0.00	4266.59	SET-20250110-GoCardless-N/A-USD	2025-01-13	NaN	2025-01-10	2025-01-10	2025-01-10	2025-01-13	GoCardless
2	PROC-TRX-96643401	MERCH_GOCARDLESS_USD	GoCardless	payment	settled	2515.78	USD	Approved	ACH	NaN	NaN	12/28	Bank of Example	Checking	NaN	PAY-0000002	CUST-PROC-4566	NaN	NaN	2.4	allow	2509.49	0.00	2509.49	SET-20250221-GoCardless-N/A-USD	2025-02-24	NaN	2025-02-21	2025-02-21	2025-02-21	2025-02-24	GoCardless
3	PROC-TRX-48503361	MERCH_CYBERSOURCE_GBP	ClientLine	payment	settled	2874.81	GBP	Approved	Credit Card	Visa	9887.0	12/28	NaN	NaN	TOK_268155	PAY-0000003	CUST-PROC-4425	Y	M	12.6	allow	2846.06	28.75	2817.31	SET-20250104-ClientLine-Visa-GBP	2025-01-07	ARN618188908	2025-01-04	2025-01-04	2025-01-04	2025-01-07	Cybersource
4	PROC-TRX-87613870	MERCH_PAYPAL_USD	PayPal	payment	settled	350.01	USD	Approved	PayPal	NaN	NaN	12/28	NaN	NaN	TOK_866077	PAY-0000004	CUST-PROC-1238	NaN	NaN	63.3	allow	347.38	0.00	347.38	SET-20250316-PayPal-N/A-USD	2025-03-19	NaN	2025-03-16	2025-03-16	2025-03-16	2025-03-19	PayPal
5	PROC-TRX-40189275	MERCH_CYBERSOURCE_USD	ClientLine	payment	settled	4412.91	USD	Approved	Credit Card	Mastercard	9534.0	12/28	NaN	NaN	TOK_244127	PAY-0000005	CUST-PROC-9562	Y	M	93.4	allow	4368.78	44.13	4324.65	SET-20250210-ClientLine-Mastercard-USD	2025-02-11	ARN591055160	2025-02-10	2025-02-10	2025-02-10	2025-02-11	Cybersource
6	PROC-TRX-13724055	MERCH_GOCARDLESS_AUD	GoCardless	payment	settled	399.15	AUD	Approved	ACH	NaN	NaN	12/28	Bank of Example	Checking	NaN	PAY-0000006	CUST-PROC-8369	NaN	NaN	96.5	allow	398.15	0.00	398.15	SET-20250207-GoCardless-N/A-AUD	2025-02-10	NaN	2025-02-07	2025-02-07	2025-02-07	2025-02-10	GoCardless
7	PROC-TRX-57320369	MERCH_GOCARDLESS_GBP	GoCardless	payment	settled	1639.12	GBP	Approved	ACH	NaN	NaN	12/28	Bank of Example	Checking	NaN	PAY-0000007	CUST-PROC-5373	NaN	NaN	50.8	allow	1635.02	0.00	1635.02	SET-20250220-GoCardless-N/A-GBP	2025-02-21	NaN	2025-02-20	2025-02-20	2025-02-20	2025-02-21	GoCardless
8	PROC-TRX-36380772	MERCH_CYBERSOURCE_USD	Amex	payment	settled	802.45	USD	Approved	Credit Card	Amex	2535.0	12/28	NaN	NaN	TOK_513827	PAY-0000008	CUST-PROC-6283	Y	M	41.0	allow	794.43	12.04	782.39	SET-20250225-Amex-Amex-USD	2025-02-26	ARN184492302	2025-02-25	2025-02-25	2025-02-25	2025-02-26	Cybersource
9	PROC-TRX-55314596	MERCH_CYBERSOURCE_USD	ClientLine	payment	settled	4780.71	USD	Approved	Credit Card	Mastercard	6108.0	12/28	NaN	NaN	TOK_505369	PAY-0000009	CUST-PROC-2142	Y	M	33.8	allow	4732.90	47.81	4685.09	SET-20250223-ClientLine-Mastercard-USD	2025-02-26	ARN314680266	2025-02-23	2025-02-23	2025-02-23	2025-02-26	Cybersource

	Processor Transaction ID	Merchant Account ID	Merchant Processor Type	Transaction Type	Transaction Status	Transaction Amount	Transaction Currency	Processor Response Code	Processor Response Message	Payment Method Type	Card Brand	Card Last 4 Digits	Card Expiration Date	Bank Name	Bank Account Type	Payment Method Token	Merchant Order ID	Customer ID	AVS Result Code	CVV/CVC Result Code	Fraud Score	Fraud Action	Gateway Net Settled Amount	Processor Fees	Net Amount to Merchant	Settlement Batch ID	Settlement Date	Acquirer Reference Number (ARN)	Transaction Timestamp	Last Update Timestamp	Payment Gateway Date	Payout Date	Payment Gateway Type
141240	PROC-TRX-32788723	MERCH_GOCARDLESS_USD	GoCardless	chargeback_reversal	disputed	689.24	USD	C02	Chargeback Reversed	ACH	NaN	NaN	12/28	Bank of Example	Checking	NaN	REV-0107910	CUST-PROC-6672	NaN	NaN	69.5	allow	687.52	0.00	687.52	SET-20250326-GoCardless-N/A-USD	2025-03-27	NaN	2025-03-26	2025-03-26	2025-03-26	2025-03-27	GoCardless
141241	PROC-TRX-72456201	MERCH_CYBERSOURCE_USD	ClientLine	chargeback_reversal	disputed	2318.44	USD	C02	Chargeback Reversed	Credit Card	Mastercard	5928.0	12/28	NaN	NaN	TOK_629291	REV-0024103	CUST-PROC-9714	Y	M	17.3	allow	2295.26	23.18	2272.08	SET-20250306-ClientLine-Mastercard-USD	2025-03-07	ARN263111260	2025-03-06	2025-03-06	2025-03-06	2025-03-07	Cybersource
141242	PROC-TRX-53974940	MERCH_CYBERSOURCE_CAD	Amex	chargeback_reversal	disputed	4353.13	CAD	C02	Chargeback Reversed	Credit Card	Amex	8590.0	12/28	NaN	NaN	TOK_952318	REV-0039969	CUST-PROC-6116	Y	M	33.3	allow	4309.60	65.30	4244.30	SET-20250311-Amex-Amex-CAD	2025-03-12	ARN135414927	2025-03-11	2025-03-11	2025-03-11	2025-03-12	Cybersource
141243	PROC-TRX-11820156	MERCH_PAYPAL_GBP	PayPal	chargeback_reversal	disputed	28.61	GBP	C02	Chargeback Reversed	PayPal	NaN	NaN	12/28	NaN	NaN	TOK_718010	REV-0101060	CUST-PROC-1705	NaN	NaN	43.7	allow	28.40	0.00	28.40	SET-20250131-PayPal-N/A-GBP	2025-02-03	NaN	2025-01-31	2025-01-31	2025-01-31	2025-02-03	PayPal
141244	PROC-TRX-37925899	MERCH_GOCARDLESS_USD	GoCardless	chargeback_reversal	disputed	2263.30	USD	C02	Chargeback Reversed	ACH	NaN	NaN	12/28	Bank of Example	Checking	NaN	REV-0020178	CUST-PROC-5907	NaN	NaN	43.4	allow	2257.64	0.00	2257.64	SET-20250124-GoCardless-N/A-USD	2025-01-27	NaN	2025-01-24	2025-01-24	2025-01-24	2025-01-27	GoCardless
141245	PROC-TRX-26208812	MERCH_GOCARDLESS_USD	GoCardless	chargeback_reversal	disputed	2573.44	USD	C02	Chargeback Reversed	ACH	NaN	NaN	12/28	Bank of Example	Checking	NaN	REV-0025245	CUST-PROC-6978	NaN	NaN	69.0	allow	2567.01	0.00	2567.01	SET-20250312-GoCardless-N/A-USD	2025-03-13	NaN	2025-03-12	2025-03-12	2025-03-12	2025-03-13	GoCardless
141246	PROC-TRX-55820069	MERCH_CYBERSOURCE_EUR	Amex	chargeback_reversal	disputed	794.03	EUR	C02	Chargeback Reversed	Credit Card	Amex	8120.0	12/28	NaN	NaN	TOK_778198	REV-0093761	CUST-PROC-4520	Y	M	36.2	allow	786.09	11.91	774.18	SET-20250101-Amex-Amex-EUR	2025-01-02	ARN131111169	2025-01-01	2025-01-01	2025-01-01	2025-01-02	Cybersource
141247	PROC-TRX-14765444	MERCH_PAYPAL_USD	PayPal	chargeback_reversal	disputed	3629.53	USD	C02	Chargeback Reversed	PayPal	NaN	NaN	12/28	NaN	NaN	TOK_797724	REV-0103102	CUST-PROC-9579	NaN	NaN	85.2	allow	3602.31	0.00	3602.31	SET-20250213-PayPal-N/A-USD	2025-02-14	NaN	2025-02-13	2025-02-13	2025-02-13	2025-02-14	PayPal
141248	PROC-TRX-18452065	MERCH_CYBERSOURCE_USD	ClientLine	chargeback_reversal	disputed	2700.28	USD	C02	Chargeback Reversed	Credit Card	Mastercard	8696.0	12/28	NaN	NaN	TOK_890568	REV-0039089	CUST-PROC-2021	Y	M	5.8	allow	2673.28	27.00	2646.28	SET-20250210-ClientLine-Mastercard-USD	2025-02-11	ARN894657558	2025-02-10	2025-02-10	2025-02-10	2025-02-11	Cybersource
141249	PROC-TRX-40563623	MERCH_GOCARDLESS_CAD	GoCardless	chargeback_reversal	disputed	2500.12	CAD	C02	Chargeback Reversed	ACH	NaN	NaN	12/28	Bank of Example	Checking	NaN	REV-0022422	CUST-PROC-1156	NaN	NaN	76.2	allow	2493.87	0.00	2493.87	SET-20250105-GoCardless-N/A-CAD	2025-01-08	NaN	2025-01-05	2025-01-05	2025-01-05	2025-01-08	GoCardless

Overview

Variables

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Common Values (Plot)

Most occurring characters